with
 member [Measures].[Tickets Totals] as
 COALESCEEMPTY(([Measures].[Revenue]), 0),
 format_string='currency'

//select
// [Dim Genre].[Genre].members on rows,
// [Measures].[Tickets Totals] on columns
//from PerformanceView;
//
//select
// [Dim Band].[Name].members on rows,
// [Measures].[Tickets Totals] on columns
//from PerformanceView;

select
 [Dim Agent].[Name].members on rows,
 [Measures].[Tickets Totals] on columns
from PerformanceView;



select
 [Measures].[Real Revenue] on columns,
 [Dim Genre].[Genre].children on rows
from OrderView






//with member [Measures].[Last Month Profit]  as 
// '(Measures.[Item Price], [Order Date].[Quarter].CurrentMember.PrevMember)',
// format_string = 'currency'
// 
// member [Measures].[Quarter Growth]  as 
// 'IIF(
//  [Order Date].[Quarter].CurrentMember.PrevMember is null,
//  null,
//  (Measures.[Item Price]) - (Measures.[Item Price], [Order Date].[Quarter].CurrentMember.PrevMember)
// )',
// format_string = 'currency'
// 
//select 
// ({[Measures].[Last Month Profit], [Measures].[Quarter Growth]}, {[Dim Genre].[Genre].[Rock], [Dim Genre].[Genre].[Metal]}) on columns,
// {
//  crossjoin([Order Date].[Year].[2010], [Order Date].[Quarter].children),
//  crossjoin([Order Date].[Year].[2011], [Order Date].[Quarter].children)
// } on rows
//from OrderView
//


//with
//	set [East Coast] as '{ 
//		[Dim Customer].[State Abbr].[NJ], [Dim Customer].[State Abbr].[VA], 
//		[Dim Customer].[State Abbr].[NH], [Dim Customer].[State Abbr].[MA], 
//		[Dim Customer].[State Abbr].[CT], [Dim Customer].[State Abbr].[RI], 
//		[Dim Customer].[State Abbr].[GA], [Dim Customer].[State Abbr].[MD], 
//		[Dim Customer].[State Abbr].[SC], [Dim Customer].[State Abbr].[NC], 
//		[Dim Customer].[State Abbr].[ME], [Dim Customer].[State Abbr].[NY], 
//		[Dim Customer].[State Abbr].[FL], [Dim Customer].[State Abbr].[DE]
//	}'
//
//select 
// crossjoin([Order Date].Year.[2011], [Order Date].Month.members) on columns,
// [East Coast] on rows
//from OrderView
//where 
// Measures.[Real Revenue]
// 
// 
// 